import sqlite3

connection  =sqlite3.connect('coachdata.sqlite')

cursor = connection.cursor()

cursor.execute(""" CREATE TABLE athletes (
                   id INTEGER PRIMARY KEY AUTOINCREMENT UNIQUE NOT NULL,
                   name TEXT NOT NULL,
                   dob DATE NOT NULL)""")
cursor.execute(""" CREATE TABLE timing_data(
                   athlete_id INTEGER NOT NULL,
                   value TEXT NOT NULL,
                   FOREIGN KEY (athlete_id) REFERENCES atheletes)""")
connection.commit()
connection.close()
                   
